Download and Configure PAS

  1. Download the domain binaries as mentioned in the Prerequisites section of this document.

  2. The coherence version run on TomEE is Coherence CE 25.03.2. Ensure you to copy the latest following configuration files from the OIPA distribution zip/conf directory into the "externallibs\pas_shared\conf" directory(This step is extremely important):

    • coherence-cache-config.xml

    • coherence-config.xml

    • PAS.properties

    • EDKeyValue.dat

    • logging.properties

    • oipakeystore.p12

      • Note: Refer to the System Properties document in the Oracle Insurance Policy Administration E62439-01 Documentation Library on the OTN for a complete list of all properties and allowed values.

  3. Update the cycle.baseURI with the cycle application URL for PAS.properties.

    Example: cycle.baseURI=http://localhost:8085/CycleService

  4. Identify the default locale in the PAS.properties file. The locale selected will determine the translation that is loaded in the database for OIPA when it launches. The default setting is English.

    application.defaultLocale

  5. It is recommended to use application.keyStorePath and application.keyStoreAlias.

    • application.keyStorePath - Absolute path including file name where the oipakeystore.p12 is located. Example: application.keyStorePath = /scratch/oipa/Oracle/oipa/conf/oipakeystore.p12.

    • application.keyStoreAlias - The alias is a unique identifier for the key entry (secret key) in the keystore.Do not modify this value unless the customer rotates the encryption key.

  6. Under the lib folder of the externallibs/pas_shared directory,

    Copy the following files from the OIPA distribution zip/libs directory into the externallibs/pas_shared/lib directory:

    • commons-collections4-4.5.0.jar

    • jakarta.persistence-api-3.2.0.jar

    • spring-instrument-6.2.18.jar

    • ha-api-3.1.13.jar

    • policy-4.0.4.jar

    • streambuffer-2.1.0.jar

    • Download aspectj 1.9.1.jar from http://www.eclipse.org/downloads/download.php?file=/tools/aspectj/aspectj-1.9.1.jar.

      • Open aspectj-1.9.1.jar with an unzipping software and retrieve aspectjrt.jar and aspectjweaver.jar from the lib folder.

      • Copy aspectjrt.jar and aspectjweaver.jar into libs sub-directory.

      Note: Rename all the jars without version names.

  7. Example:

    • commons-collections4.jar

    • jakarta.persistence.jar

    • spring-instrument.jar

    • ha-api.jar

    • policy.jar

    • streambuffer.jar

  8. To define the following environment variables at docker run time using the -e option in the command line or define them in the pas_env.dat file.

The environment configuration variables, that need to be set for the TomEE server, and application configuration are defined below:

Environment Configuration Variables

Configuration Parameters

Variable

PASJava Application Port

PAS_PORT

Server Port

SERVER_PORT

Application Redirect Port

REDIRECT_PORT

Enable AC

ENABLE_AC

JMX Port

JMX_PORT

Database Jar Used

DBJar

DataSource Configuration URL

JDBCURL

Database Username

DSUSERNAME

Database Password

DSPASSWORD

External Library Path

EXT_LIB_PATH

ATP Compatibility

ATP_COMPLIANT
Cycle Trust store password CYCLE_TRUSTSTORE_PASSWORD
Outbound Trust store password OUTBOUND_TRUSTSTORE_PASSWORD

 

Note: Refer to the pas_env.dat file for more information regarding these variables.

  1. PAS_PORT: Mention the PASJava Application port.

    Example: PAS_PORT=7001

  2. SERVER_PORT: Mention the Server Port.

    Example: SERVER_PORT=8001

  3. REDIRECT_PORT: Mention the Application Redirect Port.

    Example: REDIRECT_PORT=7441

  4. ENABLE_AC: This variable denotes whether the application is further connected to the Admin Console or not. Choose the appropriate option before provisioning the environment.

    Example: ENABLE_AC=Yes

    ENABLE_AC=No

  5. JMX_PORT: Mention this port in order to expose JMX for remote connection.

    Example JMX_PORT=5555

  6. DBJar: Based on the Database used for the application, mention the relevant jar.

    Example:

    Oracle: DBJar=ojdbc.jar

    DB2: DBJar=db2jcc4.jar

    MSSQL: DBJar=mssql-jdbc.jar

  7. CYCLE_TRUSTSTORE_PASSWORD : Cycle trust store password to establish SSL connection with Cycle server.

    8. OUTBOUND_TRUSTSTORE_PASSWORD: Out bound trust store password to establish SSL connection with Outbound server.

    9. JDBCURL: Mention the DataSource Configuration URL based on the database selected.

    ORACLE:

    JDBCURL=jdbc:oracle:thin:@<host>:<port>:<sid>

    DB2:

    JDBCURL=jdbc:db2://<host>:<port>/<databasename>:currentSchema=<schemaname>;

    if the schema name and username are different, please append currentfunctionpath to above url.

    Example:

    jdbcDriver = com.ibm.db2.jcc.DB2Driver

    jdbcUrl = jdbc:db2://<host>:<port>/<databasename>:currentSchema= <schemaname>;currentFunctionPath=SYSIBM,SYSFUN,SYSPROC,SYSIBMADM,SYSHADOOP,USERNAME,SCHEMANAME;

    Example: For SQL Server

    When the encrypt property is set to true and the trustServerCertificate property is set to true, the Microsoft JDBC Driver for SQL Server won't validate the SQL Server TLS certificate. This setting is common for allowing connections in test environments, such as where the SQL Server instance has only a self-signed certificate.

    jdbcUrl = jdbc:sqlserver://<host>:<port>;DatabaseName=<databasename>;encrypt=true;trustServerCertificate=true

  8. DSUSERNAME: Mention the username for the Data Source.

  9. DSPASSWORD: Mention the password for the Data Source.

  10. EXT_LIB_PATH: Define the Package Location inside the container (it is configured based on the base image used. No need to change the value of it).

    Example: EXT_LIB_PATH=/usr/local/tomee/externallibs

  11. ATP_COMPLIANT: This variable denotes whether the application is in compliance with ATP or not. Choose the appropriate option before provisioning the environment.

    Example: ATP_COMPLIANT=Yes

    If the PAS application is ATP compliant, then copy the required ATP (Autonomous Transaction Processing) database files under the externallibs/pas_shared/atp directory.

    The following parameters need to be updated in the pas_env.dat file and the below jars need to be downloaded and copied to ojdbc folder

    Add following dependent JARs for ATP

    Add the following dependent JARs for ATP, following JDBC JAR files (JDBC Release 18.3 and above): are required to have a successful database connection: The jars must be placed under /usr/local/tomee/externallibs/pas_shared/atp/ojdbc directory

    Note: Download the JAR files here

    JAR Required Description
    ojdbc.jar  Required

    JDBC Thin Driver, follow OIPA installation documentation for supported JDBC driver version.
    ons.jar Optional

    Only needed in case FAN (Fast Application Notification) is configured for Oracle RAC cluster.
    oraclepki.jar Required

    Oracle PKI (public key infrastructure) provider for Oracle Wallets.
    osdt_cert.jar Required

    Oracle Security Developer Tool Certificates.
    osdt_core.jar Required

    Oracle Security Developer Tool Core.
    ucp.jar Required

    Universal Connection Pool.
Autonomous Transaction Processing Database (ATP) Variables

ATP Configuration Parameters

Variables

Wallet Location

WALLET

TNS DB name

WALLETDB

ATP Wallet Username

WALLETUSERNAME

ATP Wallet Password

WALLETPASSWORD

ATP Proxy

ATP_PROXY

ATP Proxy Port

ATP_PROXY_PORT

  • WALLET: Update the WALLET directory location ( which is preconfigured based on the container structure)

    Example: WALLET=/usr/local/tomee/externallibs/pas_shared/atp/wallet/

  • WALLETDB: Open tnsnames.ora file (present in the wallet) and note the TNS name that is suffixed with _tp for transaction processing.

    Example: WALLETDB=oipadb_tp

  • WALLETUSERNAME: Mention the username for the ATP connection

  • WALLETPASSWORD: Mention the password for the ATP connection

  • ATP_PROXY: The ATP instance is on Public IP, if connecting over VPN, then you need to use an HTTP: PROXY

    Example: ATP_PROXY=www-proxy-hqdc.us.oracle.com

  • ATP_PROXY_PORT:- Mention the HTTP: PROXY PORT

    Example: ATP_PROXY_PORT=80

The sample folder structure is as follows:

OIPA Docker TomEE Odjbc folder

Under ojdbc folder copy all the libs downloaded.

Under wallet folder

OIPA Docker TomEE Wallet folder